-
"Return (T-SQL)" and recordset (ASP)
We have an "insert-update" stored procedure that is referenced by our ASP page (using "rs.open (SQLstring)"
If the stored proc inserts values in the table, it returns the Identity Value:
"
select @NewRowNum = @@IDENTITY
return @NewRowNum
"
When we execute the stored proc from the ASP, it actually inserts a new row in our table, but we cannot get the @NewRowNum...
Does anyone know how can we get this value in the ASP page from our recordset?
Thank you very much,
Anastasia.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|